MacWorld 1998 January/Macworld (1998-01).dmg/FileMaker Pro 4/Full FM4 Templates/Business/Club Membership

FileMaker Pro Database | 1997-09-14 | 137KB | 854 lines

Field Trip Summary
Open Script
HBAM2016AUG95
Pro 3.0
@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<H
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!L
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
HBAM3016AUG95
Pro 2.0 - 2.1F!
Pro 3.0
BUS CITY
BUS NAME
d    BUS PHONE
j    BUS STATE
BUS STREET
BUS ZIP CODE
COUNTRY
CREATED BY
DATE BIRTH
DATE CREATED
DATE INITIATED
DATE MEMBERSHIP TERMINATED
DATE MODIFIED
DATE OF ANNIVERSARY
DATE OF LAST DUES CYCLE
DATE OF LAST PAYMENT
DATE OF NEXT DUES CYCLE
DATE OF THIS DUES CYCLE
DUES ARE LATE
~    DUES PAID
EMAIL ADDRESS
FIRST NAME
X    HOME CITY
HOME PHONE
HOME STATE
HOME STREET
HOME ZIP CODE
LAST LAYOUT
    LAST NAME
W    MEMBER ID
MIDDLE NAME
NOTES
OFFICER
OFFICES HELD
REFERRED BY
SPOUSE'S NAME
YEARS OF MEMBERSHIP
Sunday
Monday
Tuesday
    Wednesday
Thursday
Friday
Saturday
January
February
March
April
August
    September
October
November
December
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
7/29/975
Form View - Membership
A    List View
Information
Report Menu
Member Phone List
Form View - Personal
Form View - MembershipB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
A    Member IDB
reatedB
Date ModifiedB
WA    Last NameB
First NameB
Home StreetB
`A    Home CityB
Home StateB
X1The state field should only contain 2 characters.
a ) = 2 )
a ) )
Home ZIP CodeB
Middle NameB
Bus NameB
Bus StreetB
Bus CityB
gA    Bus StateB
X1The state field should only contain 2 characters.
g ) = 2 )
g ) )
Bus ZIP CodeB
Home PhoneB
jA    Bus PhoneB
Date InitiatedB
Referred ByB
Date BirthB
CountryB
Date of AnniversaryB
Spouse's NameB
Date Membership TerminatedB
Offices HeldB
OfficerB
NotesB
Date of Last PaymentB
Date of Next Dues CycleB
b) + 1
Date of This Dues CycleB
}A    Dues PaidB
 "No"
 "Yes")
Dues Are LateB
 "No"
 "Yes"
 "No"))
Date of Last Dues CycleB
b) - 1
Years of MembershipB
EMail AddressB
InfoB
Created ByB
Last LayoutB
Description
Use this file to manage club membership information.  Easily keep track of when member's renewal fees are due.
How to use this solution
Use the Membership and Personal tabs to enter and view information about the current member. You can view and print a report of members' phone numbers.
How to customize this solution
Create reports that list members by start date or by company. Add email to the Phone Numbers report.
Create a layout that reminds you of upcoming birthdays or B
anniversaries. You can simply find all birthdays in the coming month and display them in a report. Or, you can add a calculation field that compares today's date against the birth date  and then create a report of all birthdays in the next 30 days.
u) -
l) / 365))
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
wwxwwxw
ggvgvv
gvwxgwghg
vhgvvww
fvfgfwffv
eVefefe
VvffVefVVefUe\
ffFdeefeefddfDeVdfEdfFdffk
EUeFFEUFEUFFUeTeVFeUUdVEEk
UTdUTeETeETeEUFTUTUFTUUTeK
TEETEETUETUETUDUDEETUDTUE[
4CDD4E4ET
D4DD4CDDC
C3C3C34C4C3CC43C
"#""3"129
#11#22122"3!
A    List ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Your Own
Button
Your Own
Button
Record
Delete
Record
Record
Reports
View As
View As
Close
Offices Held
Current Office
Referred By
Years of Membership
Termination
Initiation
Notes
Overdue?
    Paid Yet?
Date of Last Payment
Current Cycle
    Member ID
    Last Name
First Name
(Enter Membership Information for Members
Membership
Personal
InformationB
Yesfter
Noarter
\*Click to see more information for a Member]
Late?^
Paid?_
Last Payment`
Home Phonea    Last Nameb
First Name
\*Click to see more information for a Member]
Late?^
Paid?_
Last Payment`
Home Phonea    Last Nameb
First Name
Your Own
Buttond
Your Own
Buttone
Recordf
Delete
Recordg
Recordh
Reportsi
View As
Listj
View As
Formk
Closel
Report MenuB
Your Own
ButtonI
ReportsJ
View As
ListK
View As
FormL
CloseM
InfoO.Information about the Club Membership solutionP
Info for this Solution
out the Club Membership solutionP
Info for this Solution
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
InfoG
Your Own
ReportH
Your Own
ReportI
Your Own
ReportJ
Member Phone ListK>Click on any of these buttons to preview the respective reportL
Select a report
ReportH
Your Own
ReportI
Your Own
ReportJ
Member Phone ListK>Click on any of these buttons to preview the respective reportL
Select a report
Member Phone ListB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Your Own
ButtonB
ReportsC
View As
ListD
View As
FormE
CloseF
Form View - PersonalB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Your Own
Button
Reports
View As
View As
Close
Bus. Phone
Business
Home Phone
t    Last Name
First Name
Page ##
Member Phone List
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Your Own
Button
Your Own
Button
Record
Delete
Record
Record
Reports
View As
View As
Close
Anniversary
Spouse's Name
Your Own
Button
Your Own
Button
Record
Delete
Record
Record
Reports
View As
View As
Close
Anniversary
Spouse's Name
Birthday
    Bus Phone
E-Mail
Home Phone
ZIP Code
Address
Business
Country
ZIP Code
Address
    Member ID
    Last Name
First Name
&Enter Personal Information for Members
Membership
Personal
Member List
Open Script
Dial Home Phone
InfoI
CloseJ
View As
FormK
View As
ListL
ReportsM
Your Own
Button
Dial Work Phone
Cancel
Specify Field
Use Dialing Preferences
Phone Number
Field Value
Number
)=400
Cancel
</ ? ?<
F/ ? ?<
You did not enter any find criteria; all records will be displayed.C+
) = 0
Cancel
Specify Field
Use Dialing Preferences
Phone Number
Field Value
Number
A    List View
Report Menu
Information
Cancel
</ ? ?<
F/ ? ?<
No records match this request.E+
) = 1
Information
    List View
Report Menu
Sort by Last Name
Member List
Open Script
Dial Home Phone
Dial Work Phone
Sort by Last Name
Member List
Open Script
Dial Home Phone
#11#22122"3!
"#""3"129
C3C3C34C4C3CC43C
DDCD4DD4CDDC
4CDD4E4ET
TEETEETUETUETUDUDEETUDTUE[
dUTeETeETeEUFTUTUFTUUTeK
EUeFFEUFEUFFUeTeVFeUUdVEEk
ffFdeefeefddfDeVdfEdfFdffk
eVefefe
VvffVefVVefUe\
fvfgfwffv
ggvgvv
gvwxgwghg
vhgvvww
Ejwwg
wwxwwxw
wwwwww
    ffffff
UUUUUU
DDDDDD
#4EWp
"4EVx
#3EVg
"4DUg
"#4DVg
24EVgy
"34EVw
##4Efw
""3DUgw
""33DUfw
""34DVgx
""#34EVgx
"#33DEfw
"    234DUfw
2""2334DEVgx
3    4DEUfwx
wwwwww
    ffffff
UUUUUU
DDDDDD
wwffeffg@
veUEDDCC
vUTDD44
vUDDC32
#""#
weUDD3
veTDC2233#3#2
wUDDC3##"
vUTD3#22
vUDDC
fUD42233##3#"!
vTDCC##"
eUDC3223##
fTD4C3##23#""
uTDC3323#2""!
22"2"
##2"!
fTDD33#22""
vUDC32"2""
WUTC22
eTD3#""
GDC32"!!
eD3#"!
T32""
"%UR
UD33D
3    DDUVgw
D    EUUfwx
UDDEUUfgw
U    Vfgwx
eUVfgww
wwwwww
    ffffff
UUUUUU
DDDDDD
3333B
""""""
B"#B@
B"#B"$
4"2$B"#B"#C
2$""#B"#C0
4"2#B"#C0
2$B"D0#C0
4""#C0
AD@D@
AD@D@
44444
CCCCC 44444 CCCCC
$42"
@@BA@
bRBBP0
UUUUU
(*)(%,3&
)%+@6)
",30,)%
 JJJJ
!BBBB
"99BB
#9999
$9911
%1111
&))))C
'!!!!
 *00**-
*00-00
00*0)
00*&0#
## !0*!%00+#!*0##-0'"0*#%00.!
UUUUUU
wwwwww
 #*>A6332+$"!
25,878
#&$690*"
!)0,++)(
 "%/66435/'#
+3;4*=
!#,@9,)+,(""(-/,,*,1!
!$&(265389,#!$$
'275?
$*23/$
$),-..)''
!$&)(-5439@1!!&*-3/)!!%6B)
)220(!$*.,,.'
!$&*,*023:?B+*.,/3254.'
"++,3/(.584.,"
!#&+/-./3:9@G@60/16883)!
$++//'(9CD>4.$$
$%)*-//2693,.075-&)3792,$
")-1347<>@G71(!
**)&'*.0350+%(=A2'%)579<94(
+/11!
!%'),342)1?=0)"
.1,$',-01)*).AG6-/048:<H
/2583$%+66/%
 %)++*),+&%06,%$#
!/40')-/31$$,@HFC<6887:==@B7%!
6A235,%
+,/13.%#"(16+
!#$(04-$&+,+$
%2>D6,59:989889=0
,.22<=33*
.22671#
!!&/42&
*1$&+,/3779733,
 $$PQ
/004B6*
!$$ $))'/3)
%&$&.7;4
)2$)*3-)466/%$
!),02+'
%$5)%*+%$!
(+'0:==4
$+,,1643"%)"
!)/1)*+
+7=-%%&$!
!3)3=.
%&*/3113
 !$$PQ
',4-%)/)
,6/%$$"
+(!<-
%),0354-
.13-&,-*
14'$$!
%))&%$!
'3*$$"
!&$%3
&%"%&
9836'
)&#%%!
$*)++"
.-/:%
!"&)()15,
)" /.-+)!L
//6B&
 #'*,.42$
$/,-*%
IF1A1
"%.2/-*#!
$/.,*($!#$"%PQ
#57-*'$#"$&'
..//.-,)'(.212PQ
",,)&%'.;<6/+',,)%!
'//,+//*)+.4:=>PQ
$(&(),5?@:2/,,''*$
-!,,%.0%)./7
#43((+9CA=3+N
&*)2!$96;;48@??PQ
)/01%$
#3/').:@<3)$&)!
/)4$%)8=A@?><@PQ
!.0/.+//./1//*
*.').3784/%
,,#%()25:<99=PQ
%10//O
0 /+134,.25653."
)++-!
# %0,*,384'%PQ
42//11/&(/563135650(
(./36$
!"23.,27-
6:=<)&931-13-!$.69433563+
,/258 #$,96-37)$!P
38;?B>;63/.22.-068934673(
,638<6$
*),/6."')==138*$)PQ
35:=@B>953-/1.-368<:8995&
%668:9(
)$'*.:&$*==8/,
-19=@CA>:83+2.,0157:
!""/88$
!)*# 6/0%
&' !$*38,.<;60"
+07=@CD=6>@.*)&(*-03;@@<-
6.3/%
#/23989=2,*%
/039>B@ "9E7,)+/3667:?CE/!"
$$%199207/
9K8@)
3933"
!0042381%$(.-)56PQ
556:=@@
5C958=BGGA96;='"+-
!!%.R
94.6BDCFM='(204967&
//2346%
$59232$PQ
:9<@?@C% 6D;;CJLONG952
(9304=FCDDE>%
$,585'
!.//11'$/;81$
9:CE><D3,5G@@HF>IF94)
$#%+*159C=:>FG)
*31*#
$/51#
89C=.!:9=C<9AFGS
CA7&(
/%3%!'+5A<6=C>$
-672.3<<961.%!
,,%=<9/69/02.
"773//33/,+)
/1$'9<3)"
069850(*)'%
%/+$
!&##34
%0<PQ
%"$:C9.*$
!+6@PQ
"$$6CD>>5
!##()
".;CPQ
 %'0>GFA:378+&&%$$,&
,:CPQ
$(,0V
27CGG@6681//,)%$/
'7CPQ
!%*/1,/44CC;6547@=2*!%.$
%;CPQ
'$)=3
 #%)*())3DLHB
?MB9/% !
"'6?6$
*;=PQ
$%&,9D6
!$%#"&)-:FIJHFGFBN@91)%"#(,/./:/#$-46PQ
!)/38;@(
"$$!"+29?DGIJKMLEIC83)'&-7:73)%$!!,5:PQ
+/0,$%&%%,26:5)
"$%&(/7;<=BGIJIGMG=953'%(1<<63/!
$*.8PQ
6=@?<3),3:8$
!&((),3=;::=EHIC:<F3)'""#&+/,',
#&(0PQ
FC8:CF@7/08<(
"'()*,169?:6=C=2..3'"
"%&)PQ
HD99=A@9534/
!26(%5,
! !),''*-16<@=430/,+/)!
??979>@@:-!
!$+%-*),/37<@:2/-*)+*"
4?=95;@@9&
*#%.,/136884/,)'),,%)+(%$$
/>C:13?@9)$
!!89+
!)$%*-/13321/,Z
*3*)-/0/+&$$!
 6A:0,8B=1+)/68.%/(,9=2%
")$"%)-02331/31)/().241+%##!
*79/)/:<651/33)2<8.6=9.
!$%,56643/75,'&).340+&#!$$%#!
.5.)/46682%#$$-973:=<7[
!$'+4:964063+(
,33/+(&'),*)'#
"%%.2379:1&"%(&.36@?@D5
!$%')/8:86>=2)&!!-231
34772+*
 &46339C@4+,3/)/:<D/8J='
"%'))+336@3(/)%#%,34569<=?CE5,)!
 #'21\
.7@C>9;99<9@CAE05J?,%$(.33/+,/26/)(,&
#,0258<?ADGE2 "'(#
"%),,/6983$
&4<9+4DD>?J>/*-6;<6,,/25.))3,'
",.0369;=AGE.
!%%(,.040'
2A?EA4*+/683*.493/($!/-,
0246689:AC7%
$%##(.23&
:96,#"%)*(%(364,%"!!"560&)/<9;989;>3$
"03., PQ
UUUUUU
wwwwww
~ffff
ffffff
ffff33
ff33ff
ff3333
33ffff
33ff33
333333
wwwwww
UUUUUU
DDDDDD
""""""
    Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
Modern
Date CreatedB
Date ModifiedB
WA    Last NameB
First NameB
Home StreetB
`A    Home CityB
Home StateB
X1The state field should only contain 2 characters.
a ) = 2 )
a ) )
Home ZIP CodeB
Middle NameB
Bus NameB
Bus StreetB
Bus CityB
gA    Bus StateB
X1The state field should only contain 2 characters.
g ) = 2 )
g ) )
Bus ZIP CodeB
Home PhoneB
jA    Bus PhoneB
Date InitiatedB
Referred ByB
Date BirthB